package com.ruoyi.system.service;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.SysYyZhouhuiFixed;

/**
 * SysYyZhouhuiFixedService接口
 * 
 * @author SYF
 * @date 2025-06-10
 */
public interface ISysYyZhouhuiFixedService 
{
    /**
     * 查询SysYyZhouhuiFixed
     * 
     * @param yYear SysYyZhouhuiFixed主键
     * @return SysYyZhouhuiFixed
     */
    public SysYyZhouhuiFixed selectSysYyZhouhuiFixedByYYear(String yYear);

    /**
     * 查询SysYyZhouhuiFixed列表
     * 
     * @param sysYyZhouhuiFixed SysYyZhouhuiFixed
     * @return SysYyZhouhuiFixed集合
     */
    public List<SysYyZhouhuiFixed> selectSysYyZhouhuiFixedList(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    /**
     * 新增SysYyZhouhuiFixed
     * 
     * @param sysYyZhouhuiFixed SysYyZhouhuiFixed
     * @return 结果
     */
    public int insertSysYyZhouhuiFixed(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    /**
     * 修改SysYyZhouhuiFixed
     * 
     * @param sysYyZhouhuiFixed SysYyZhouhuiFixed
     * @return 结果
     */
    public int updateSysYyZhouhuiFixed(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    /**
     * 批量删除SysYyZhouhuiFixed
     * 
     * @param yYears 需要删除的SysYyZhouhuiFixed主键集合
     * @return 结果
     */
    public int deleteSysYyZhouhuiFixedByYYears(String[] yYears);

    /**
     * 删除SysYyZhouhuiFixed信息
     * 
     * @param yYear SysYyZhouhuiFixed主键
     * @return 结果
     */
    public int deleteSysYyZhouhuiFixedByYYear(String yYear);

    public List<Map<String,Object>> selectZhStatu(String year);

    public List<Map<String,Object>> selectBigDepts(String year);

    public List<Map<String,Object>> selectSubDepts(String year);

    public List<Map<String,Object>> selectBrands(String year);

    public List<Map<String,Object>> selectYears(String year);

    public List<Map<String,Object>> selectSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectSubDeptSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectBrandSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectDetailSummaryData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectSubDeptTotalData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public List<Map<String,Object>> selectBrandsTotalData(SysYyZhouhuiFixed sysYyZhouhuiFixed);

    public Map<String,Object> selectCustomerSummary(String month);

    public Map<String,Object> selectCustomerSummaryByArea(String month,String area);

    public Map<String,Object> selectCustomerSummaryMap(String sql);

    public List<Map<String,Object>> selectCustomerAreasInfo();

    public List<Map<String,Object>> selectCustomerYearsInfo();

    public List<Map<String,Object>> selectCustomerYearsAscInfo();

    public List<Map<String,Object>> selectCustomerIncreaseSummary(String sql);

    public List<Map<String,Object>> selectCgQtyList(String sql);

    public List<Map<String,Object>> selectCgMoneyList(String sql);

    public List<Map<String,Object>> selectCgDetailList(String sql);

    public List<Map<String,Object>> selectCgTotalSummary(String sql);

    public List<Map<String,Object>> selectRisePriceSummary(String sql);

    public List<Map<String,Object>> selectCgVendorSummary(String sql);

    public List<Map<String,Object>> selectCgMonthSummary(String sql);

    public List<Map<String,Object>> selectWeeksInfo(String sql);

    public List<Map<String,Object>> selectSourcesInfo(String sql);

    public List<Map<String,Object>> selectPlatFansTypes(String sql);

    public List<Map<String,Object>> selectPlatFansYears(String sql);

    public List<Map<String,Object>> selectPlatFansData(String sql);

    public List<Map<String,Object>> selectWeekIncreaseSummary(String adtime);

    public List<Map<String,Object>> selectWeekIncreaseSummaryByArea(String area,String adtime);

    public List<Map<String,Object>> selectLastWeekCustomers(String year);

    public List<Map<String,Object>> selectBigDeptsFg();

    public List<Map<String,Object>> selectFgAreaSummary();

    public List<Map<String,Object>> selectFgAreaSummaryByArea(String area);

    public List<Map<String,Object>> selectFgMonthBigDeptAndArea(String year,String area);

    public List<Map<String,Object>> selectFgMonthDepts(String year);

    public List<Map<String,Object>> selectFgMonthAreaSummary(String area);

    public List<Map<String,Object>> selectFgMonthAreaSummaryByArea(String year,String area);

    public List<Map<String,Object>> selectFgMonthData(String year,String area);

    public List<Map<String,Object>> selectCgCls(String year);

    public List<Map<String,Object>> selectCgIfwk(String year);
}
